Update a Customer in the customer table of the Body Shop database


Select a Customer to update:


SELECT * FROM Customer WHERE customerID=''

Customer ID:
First Name:
Last Name:
Address:
Phone:



The sql for the update
UPDATE Customer SET lastName = '', firstName = '', address = '', phone = '' WHERE customerID = '';


Back to the body shop page
Back to my home page